Cost Reduction Strategies by Palani Murugappan

Author:Palani Murugappan [Murugappan, Palani]
Language: eng
Format: azw3
Publisher: Blue Micro Solutions
Published: 2014-09-11T04:00:00+00:00

Move to the Pmt text box. Collapse the dialog box. Select cell C2. This is the amount affordable per month.

Expand the dialog box. Press the F4 key once. The relative cell C2 becomes an absolute cell i.e. $C$2. Absolute referencing is used to facilitate the copying process of the formula later.

Click the button to close the Function Arguments dialog box.

Click the Decrease Decimal ( ) icon button on the Formatting toolbar twice to round the present value in cell B5. The present value of cell B5 should be $22,144 i.e. this is the amount of car loan you can afford for a 4 year loan at 4 percent interest rate based on the monthly payment of $500.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.